Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_INDEXTYPES

`ALL_INDEXTYPES` displays information about the indextypes accessible to the current user.

Related Views

- `DBA_INDEXTYPES` displays information about all indextypes in the database.

- `USER_INDEXTYPES` displays information about the indextypes owned by the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the indextype
`INDEXTYPE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the indextype
`IMPLEMENTATION_SCHEMA` | `VARCHAR2(30)` | `NOT NULL` | Name of the schema for the indextype implementation (that is, containing the indextype operators)
`IMPLEMENTATION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the indextype implementation type
`INTERFACE_VERSION` | `NUMBER` |  | Version of the indextype interface
`IMPLEMENTATION_VERSION` | `NUMBER` | `NOT NULL` | Version of the indextype implementation
`NUMBER_OF_OPERATORS` | `NUMBER` |  | Number of operators associated with the indextype
`PARTITIONING` | `VARCHAR2(10)` |  | Kinds of local partitioning supported by the indextype: `NONE` `RANGE` `HASH` `HASH,RANGE`
`ARRAY_DML` | `VARCHAR2(3)` |  | Indicates whether the indextype supports array DML (`YES`) or not (`NO`)

See Also: "DBA_INDEXTYPES" "USER_INDEXTYPES"